Accounts payable

File layout

  • Recommend the file name begin with “AP_”
    • Example: AP_Actual2020_JAN
  • Each month should have a file, and each file should have a unique file name.

Field Description Field Type Length
Entity Entity or Hospital Identification Code Numeric 5
Dept Department or Cost Center Number Numeric 10
Acct GL Account Number Numeric 10
Vendor Number Vendor Number Text 25
Vendor Name Vendor Name Text 50
PONum Purchase Order Number Text 25
ItemNoDesc Item\Line Number Description Text 100
InvoiceNum Invoice Number Text 50
Amount Dollar Amount Decimal 11.2
CheckNo Check Number Text 25
VendorImageLink URL to vendor image location Text 1000

Sample file layout